home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Frequent Flyer Database (.txt) < prev    next >
FileMaker Pro Database  |  1996-01-25  |  99KB  |  643 lines
  1. J*QU^
  2. HBAM2016AUG95
  3. Pro 3.0
  4. Ip8@5
  5. Lj!QQ
  6. H|R9E
  7. =5"d,
  8. HBAM3016AUG95@
  9. HP DeskJet 540 Printer
  10. Pro 2.0 - 2.1F!
  11. Pro 3.0
  12.     AIR MILES
  13. AIR MILES PLUS BONUS MILES
  14. BONUS MILES
  15. DATE CREATED
  16. DATE MODIFIED
  17. DESCRIPTION
  18. MILES CALC
  19. `    RECORD ID
  20. TOTAL AIR MILES
  21. TOTAL BONUS MILES
  22. TOTAL MILES
  23. TOTAL MILES CALC
  24. TRANSACTION DATE
  25. TRANSACTION TYPE
  26. TRAVEL FROM
  27. Y    TRAVEL TO
  28. A    Record IDB
  29. Date CreatedB
  30. Date ModifiedB
  31. DescriptionB
  32. Transaction DateB
  33. RA    Air MilesB
  34. Bonus MilesB
  35. Air Miles Plus Bonus MilesB
  36. Total MilesB
  37. Travel FromB
  38. ZA    Travel ToB
  39. Total Air Miles
  40.     USENG.NDX
  41. Sunday
  42. Monday
  43. Tuesday
  44.     Wednesday
  45. Thursday
  46. Friday
  47. Saturday
  48. January
  49. February
  50. March
  51. April
  52. August
  53.     September
  54. October
  55. November
  56. December
  57. 1st Quarter
  58. 2nd Quarter
  59. 3rd Quarter
  60. 4th Quarter
  61. 11/20/95
  62. Description
  63. Use this database to keep track of your frequent flyer miles.
  64. How to use this solution
  65. Enter your frequent flyer transactions into the form. You can keep track of miles you receive from flying or from credit card transactions, hotel stays, and so on. You can also keep track of the miles you redeem, by entering a debit transaction.
  66. When you need to know how many frequent flyer miles you have earned, you can use the Mileage Summary report.
  67. How to customize this solution
  68. You caB
  69. n track frequent flyer miles for more than one person by adding a name field. You can link this name field to another database using relations. For instance, you might want to keep track of miles for employees or travel agency customers.
  70. A    Form View
  71. A    List View
  72. Mileage Summary
  73. Information
  74. Total Bonus MilesB
  75. Transaction TypeB
  76. Credit
  77. Miles CalcB
  78. _ = "Credit"
  79. Credit
  80. Total Miles CalcB
  81. InfoB
  82. A    Form ViewB
  83. Report Menu
  84. A    List ViewB
  85. Your Own
  86. Button
  87. Your Own
  88. Button
  89. Record
  90. Delete
  91. Record
  92. Record
  93. Reports
  94. View As
  95. View As
  96. Close
  97. Total Mileage:
  98. Bonus Miles:
  99. Air Miles:
  100. Transaction Type
  101. Description
  102. |#Enter data for Frequent Flyer Miles
  103. Air Mileage
  104. Transaction
  105. Mileage SummaryB
  106. Total[
  107. Bonus\
  108. Type^
  109. From`
  110. Descriptiona
  111. Dateb
  112. Your Own
  113. Buttonc
  114. Your Own
  115. Buttond
  116. Recorde
  117. Delete
  118. Recordf
  119. Recordg
  120. Reportsh
  121. View As
  122. Listi
  123. View As
  124. Formj
  125. Closek
  126. Infol*Click to see more information for a record
  127. InformationB
  128. Your Own
  129. Button
  130. Reports
  131. View As
  132. View As
  133. Close
  134. Balance:
  135. Page ##
  136. Mileage Summary
  137. Bonus
  138. Total
  139. Description
  140. Report MenuB
  141. Your Own
  142. ButtonI
  143. ReportsJ
  144. View As
  145. ListK
  146. View As
  147. FormL
  148. CloseM
  149. InfoO-Information about the Frequent Flyer solutionP
  150. Info for this Solution
  151. about the Frequent Flyer solutionP
  152. Info for this Solution
  153. Your Own
  154. ReportB
  155. Your Own
  156. ReportC
  157. Your Own
  158. ReportD
  159. Mileage SummaryE
  160. Your Own
  161. ButtonF
  162. ReportsG
  163. View As
  164. ListH
  165. View As
  166. FormI
  167. CloseJ
  168. InfoK>Click on any of these buttons to preview the respective reportL
  169. Select a report
  170. ButtonF
  171. ReportsG
  172. View As
  173. ListH
  174. View As
  175. FormI
  176. CloseJ
  177. InfoK>Click on any of these buttons to preview the respective reportL
  178. Select a report
  179. 06/09/95Y
  180. 09/12/95
  181. AA 538
  182. 4/8/95
  183. Credit
  184. 06/09/95Y
  185. 01/13/96
  186. AA 2022
  187. 4/8/95
  188. Credit
  189. 06/09/95Y
  190. 06/09/95
  191. AV 7 DY Buffalo APO NY
  192. 4/8/95
  193. Credit
  194. 06/09/95Y
  195. 06/09/95
  196. AA 1861
  197. 4/14/95
  198. Credit
  199. 06/09/95Y
  200. 06/09/95
  201. AA 1467
  202. 4/14/95
  203. Credit
  204. 06/09/95Y
  205. 06/09/95
  206. QQ 580
  207. 4/20/95
  208. Credit
  209. 06/09/95Y
  210. 06/09/95
  211. AV 1 DY John Wayne APO CA
  212. 4/20/95
  213. Credit
  214. 06/09/95Y
  215. 06/09/95
  216. AV 1 DY Oregon-Portland AP
  217. 4/20/95
  218. Credit
  219. 06/09/95Y
  220. 06/09/95
  221. AV 4 DY Phoenix APO AZ
  222. 4/24/95
  223. Credit
  224. 06/09/95Y
  225. 06/09/95
  226. AV 1 DY Ontario APO CA
  227. 5/1/95
  228. Credit
  229. Your Own
  230. ButtonB
  231. ReportsC
  232. View As
  233. ListD
  234. View As
  235. FormE
  236. CloseF
  237. debit
  238. credit
  239. credit
  240. buffalo
  241. wayne
  242. oregon-portland
  243. phoenix
  244. ontario
  245. purchases
  246. purchases
  247. debit
  248. Sort by Date
  249. Sort by Description
  250. Sort by Transaction Type
  251. Sort for Mileage Summary
  252. Mileage Summary
  253. Open Script
  254. Sort by Date
  255. Sort by Description
  256. 06/09/95Y
  257. 01/13/96
  258. Bank Card Purchases
  259. 4/4/95
  260. Credit
  261. 06/09/95Y
  262. 09/13/95
  263. Bank Card Purchases
  264. 5/4/95
  265. Credit
  266. 06/09/95Y
  267. 09/12/95
  268. AA 538
  269. 4/8/95
  270. Debit
  271.     Helvetica
  272. Geneva
  273. Times
  274. Times New Roman
  275. Arial
  276. MS Sans Serif
  277. CWF_Mono
  278. Mileage Summary
  279. Sort by Transaction Type
  280. Sort for Mileage Summary
  281. Open Script
  282. Cancel
  283. You did not enter any find criteria; all records will be displayed.C)
  284. Cancel
  285. No records match this request.
  286. wwwwww
  287.     ffffff
  288. UUUUUU
  289. DDDDDD
  290. 3333B
  291. """"""
  292. wwxwwxw
  293. ggvgvv
  294. gvwxgwghg
  295. vhgvvww
  296. fvfgfwffv
  297. eVefefe
  298. VvffVefVVefUe\
  299. ffFdeefeefddfDeVdfEdfFdffk
  300. EUeFFEUFEUFFUeTeVFeUUdVEEk
  301. UTdUTeETeETeEUFTUTUFTUUTeK
  302. TEETEETUETUETUDUDEETUDTUE[
  303. 4CDD4E4ET
  304. D4DD4CDDC
  305. C3C3C34C4C3CC43C
  306. "#""3"129
  307. #11#22122"3!
  308. wwwwww
  309.     ffffff
  310. UUUUUU
  311. DDDDDD
  312. 3333B
  313. """"""
  314. #11#22122"3!
  315. "#""3"129
  316. C3C3C34C4C3CC43C
  317. DDCD4DD4CDDC
  318. 4CDD4E4ET
  319. TEETEETUETUETUDUDEETUDTUE[
  320. dUTeETeETeEUFTUTUFTUUTeK
  321. EUeFFEUFEUFFUeTeVFeUUdVEEk
  322. ffFdeefeefddfDeVdfEdfFdffk
  323. eVefefe
  324. VvffVefVVefUe\
  325. fvfgfwffv
  326. ggvgvv
  327. gvwxgwghg
  328. vhgvvww
  329. Ejwwg
  330. wwxwwxw
  331. (LIST
  332. LISTA
  333. Debit
  334. Credit
  335. VDEFA(
  336. (LIST
  337. VDEFA(
  338. (LIST
  339. VDEFA(
  340. Transaction Type ListB
  341. Travel From ListC
  342. Travel To List
  343. wwwwww
  344.     ffffff
  345. UUUUUU
  346. DDDDDD
  347. wwffeffg@
  348. veUEDDCC
  349. vUTDD44
  350. vUDDC32
  351. #""# 
  352. weUDD3
  353. veTDC2233#3#2
  354. wUDDC3##"
  355. vUTD3#22
  356. vUDDC
  357. fUD42233##3#"!
  358. vTDCC##"
  359. eUDC3223##
  360. fTD4C3##23#""
  361. uTDC3323#2""!
  362. 22"2"
  363. ##2"!
  364. fTDD33#22""
  365. vUDC32"2""
  366. WUTC22
  367. eTD3#""
  368. GDC32"!!
  369. eD3#"!
  370. T32""
  371. wwwwww
  372.     ffffff
  373. UUUUUU
  374. DDDDDD
  375. #4EWp
  376. "4EVx
  377. #3EVg
  378. "4DUg
  379. "#4DVg
  380. 24EVgy
  381. "34EVw
  382. ##4Efw
  383. ""3DUgw
  384. ""33DUfw
  385. ""34DVgx
  386. ""#34EVgx
  387. "#33DEfw
  388. "    234DUfw
  389. 2""2334DEVgx
  390. 3    4DEUfwx
  391. 3    DDUVgw
  392. D    EUUfwx
  393. UDDEUUfgw
  394. U    Vfgwx
  395. eUVfgww
  396. "%UR 
  397. UD33D 
  398. AD@D@
  399. AD@D@
  400. B"#B@
  401. B"#B"$
  402. 4"2$B"#B"#C
  403. 2$""#B"#C0
  404. 4"2#B"#C0
  405. 2$B"D0#C0
  406. 4""#C0
  407. 44444
  408. CCCCC 44444 CCCCC 
  409. $42" 
  410. bRBBP0
  411. @@BA@
  412.  JJJJ
  413. !BBBB
  414. "99BB
  415. #9999
  416. $9911
  417. %1111
  418. &))))C
  419. '!!!!
  420.  *00**-
  421. *00-00 
  422. 00*0)
  423. 00*&0#
  424. ## !0*!%00+#!*0##-0'"0*#%00.!
  425. UUUUU
  426. UUUUUU
  427. wwwwww
  428. UUUUUU
  429. wwwwww
  430. (*)(%,3&    
  431. )%+@6) 
  432. ",30,)%
  433.  #*>A6332+$"!
  434. 25,878
  435. #&$690*"
  436. !)0,++)(
  437.  "%/66435/'#
  438. +3;4*=
  439. !#,@9,)+,(""(-/,,*
  440. !$&(265389,#!$$
  441. '275?
  442. " $$*23/$
  443. $),-..)''
  444. !$&)(-5439@1!!&*-3/)!!%6B)
  445. )220(!$*.,,.' 
  446. !$&*,*023:?B+*.,/3254.'
  447. "++,3/(.584.,"
  448. !#&+/-./3:9@G@60/16883)!
  449. $++//'(9CD>4.$$
  450. $%)*-//2693,.075-&)3792,$
  451. ")-1347<>@G71(!
  452. **)&'*.0350+%(=A2'%)579<94(
  453. +/11!
  454. !%'),342)1?=0)"
  455. .1,$',-01)*).AG6-/048:<
  456. /2583$%+66/%
  457.  %)++*),+&%06,%$#
  458. !/40')-/31$$,@HFC<6887:==@B7%!
  459. 6A235,% 
  460. +,/13.%#"(16+
  461. !#$(04-$&+,+$
  462. %2>D6,59:989889=0
  463. ,.22<=33*
  464. .22671#
  465. !!&/42&
  466. *1$&+,/3779733,
  467.  $$PQ
  468. /004B6*
  469. !$$ $))'/3)
  470. %&$&.7;4
  471. )2$)*3-)466/%$
  472. !),02+'
  473. %$5)%*+%$!
  474. (+'0:==4
  475. $+,,1643"%)"
  476. !)/1)*+
  477. +7=-%%&$!
  478. !3)3=.
  479. %&*/3113
  480.  !$$PQ
  481. ',4-%)/)
  482. ,6/%$$" 
  483. +(!<-
  484. %),0354-
  485. .13-&,-*
  486. 14'$$! 
  487. %))&%$!
  488. '3*$$" 
  489. !&$%3
  490. &%"%&
  491. 9836'
  492. )&#%%!
  493. $*)++"
  494. .-/:%
  495. !"&)()15,
  496. )" /.-+)!
  497. //6B&
  498.  #'*,.42$
  499. $/,-*%
  500. IF1A1
  501. "%.2/-*#!
  502. $/.,*($!#$"%PQ
  503. #57-*'$#"$&'
  504. ..//.-,)'(.212PQ
  505. ",,)&%'.;<6/+',,)%!
  506. '//,+//*)+.4:=>PQ
  507. $(&(),5?@:2/,,''*$
  508. -!,,%.0%)./7
  509. #43((+9CA=3+,)+"
  510. &*)2!$96;;48@??PQ
  511. )/01%$
  512. #3/').:@<3)$&)!
  513. /)4$%)8=A@?><@PQ
  514. !.0/.+//./1//*
  515. *.').3784/%
  516. ,,#%()25:<99=PQ
  517. %10//
  518. 0 /+134,.25653."
  519. )++-!
  520. # %0,*,384'%PQ
  521. 42//11/&(/563135650(
  522. (./36$
  523. !"23.,27- 
  524. 6:=<)&931-13-!$.69433563+
  525. ,/258 #$,96-37)$!PQ
  526. 38;?B>;63/.22.-068934673(
  527. ,638<6$
  528. *),/6."')==138*$)PQ
  529. 35:=@B>953-/1.-368<:8995&
  530. %668:9(
  531. )$'*.:&$*==8/,
  532. -19=@CA>:83+2.,0157:
  533. !""/88$
  534. !)*# 6/0%&' !$*38,.<;60"
  535. +07=@CD=6>@.*)&(*-03;@@<-
  536. 6.3/%
  537. #/23989=2,*%
  538. /039>B@ "9E7,)+/3667:?CE/!"
  539. $$%199207/
  540. 9K8@)
  541. 3933"
  542. !0042381%$(.-)56PQ
  543. 556:=@@
  544. 5C958=BGGA96;='"+-
  545. !!%.94.6BDCFM='(204967&
  546. //2346%
  547. $59232$PQ
  548. :9<@?@C% 6D;;CJLONG952
  549. (9304=FCDDE>%
  550. $,585'
  551. !.//11'$/;81$
  552. 9:CE><D3,5G@@HF>IF94)
  553. $#%+*159C=:>FG)
  554. *31*#
  555. $/51#
  556. 89C=.!:9=C<9AFGCA7&(
  557. /%3%!'+5A<6=C>$
  558. -672.3<<961.%!
  559. ,,%=<9/69/02. 
  560. "773//33/,+)
  561. /1$'9<
  562. 069850(*)'%
  563. %/+$ 
  564. !&##34
  565. %0<PQ
  566. %"$:C9.*$
  567. !+6@PQ
  568. "$$6CD>>5
  569. !##()
  570. ".;CPQ
  571.  %'0>GFA:378+&&%$$,&
  572. ,:CPQ
  573. $(,027CGG@6681//,)%$/
  574. '7CPQ
  575. !%*/1,/44CC;6547@=2*!%.$
  576. %;CPQ
  577. '$)=3
  578.  #%)*())3DLHB
  579. ?MB9/% !
  580. "'6?6$
  581. *;=PQ
  582. $%&,9D6
  583. !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
  584. !)/38;@(
  585. "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
  586. +/0,$%&%%,26:5)
  587. "$%&(/7;<=BGIJIGMG=953'%(1<<63/!
  588. $*.8PQ
  589. 876=@?<3),3:8$
  590. !&((),3=;::=EHIC:<F3)'""#&+/,',
  591. #&(0PQ
  592. FC8:CF@7/08<(
  593. "'()*,
  594. 169?:6=C=2..3'"
  595. "%&)PQ
  596. HD99=A@9534/
  597. !26(%5, 
  598. ! !),''*-16<@=430/,+/)!
  599. ??979>@@:-!
  600. !$+%-*),/37<@:2/-*)+*" 
  601. 4?=95;@@9&
  602. *#%.,/136884/,)'),,%)+(%$$
  603. />C:13?@9)$ 
  604. !!89+
  605. !)$%*-/13321/,*3*)-/0/+&$$!
  606.  6A:0,8B=1+)/68.%/(,9=2%
  607. ")$"%)-02331/31)/().241+%##!
  608. *79/)/:<651/33)2<8.6=9. 
  609. !$%,56643/75,'&).340+&#!$$%#!
  610. .5.)/46682%#$$-973:=<7)
  611. !$'+4:964063+(
  612. ,33/+(&'),*)'#
  613. "%%.2379:1&"%(&.36@?@D5 
  614. !$%')/8:86>=2)&!!-231
  615. 34772+*
  616.  &46339C@4+,3/)/:<D/8J='
  617. "%'))+336@3(/)%#%,34569<=?CE5,)!
  618.  #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
  619. #,0258<?ADGE2 "'(#
  620. "%),,/6983$
  621. &4<9+4DD>?J>/*-6;<6,,/25.))3,'
  622. ",.0369;=AGE.
  623. !%%(,.040'
  624. 2A?EA4*+/683*.493/($!/-,
  625. 0246689:AC7%
  626. $%##(.23&
  627. :96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
  628. "03., PQ
  629. )=400    
  630. Cancel
  631. You did not enter any find criteria; all records will be displayed.C)
  632. Cancel
  633. No records match this request.
  634. 12679
  635. Sort by Date
  636. Sort by Description
  637. Sort by Transaction Type
  638. Sort for Mileage Summary
  639. Mileage Summary
  640. Open Script
  641. Sort by Date
  642. Sort by Description
  643.